﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'proc_cm_GetFileshare')
BEGIN
    PRINT 'Dropping Procedure proc_cm_GetFileshare'
    DROP  Procedure  proc_cm_GetFileshare
END
GO

PRINT 'Creating Procedure proc_cm_GetFileshare'
GO

CREATE PROCEDURE [dbo].[proc_cm_GetFileshare]
	@pFileshareId uniqueidentifier
AS
BEGIN
	SET NOCOUNT ON

	SELECT 
		[fileshare_id]
		,[html_page_id]
		,[subject_txt]
		,[filename_txt]
		,[description_txt]
		,[content_type] 
		,[create_dttm]
		,[update_dttm]
		,[section_cd]
	FROM
		[dbo].[tbl_fileshare] (nolock)
	WHERE
		[fileshare_id] = @pFileshareId	
END
GO

GRANT EXEC ON dbo.proc_cm_GetFileshare TO PUBLIC
GO

